CREATE TABLE [dbo].[UD_Field]
(
[TABLE_NAME] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_UD_Field_TABLE_NAME] DEFAULT (''),
[FIELD_NAME] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_UD_Field_FIELD_NAME] DEFAULT (''),
[FIELD_TYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_UD_Field_FIELD_TYPE] DEFAULT (''),
[FIELD_LENGTH] [int] NOT NULL CONSTRAINT [DF_UD_Field_FIELD_LENGTH] DEFAULT ((0)),
[DECIMAL_POSITIONS] [tinyint] NOT NULL CONSTRAINT [DF_UD_Field_DECIMAL_POSITIONS] DEFAULT ((0)),
[PROMPT] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_UD_Field_PROMPT] DEFAULT (''),
[VALIDATION_TABLE] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_UD_Field_VALIDATION_TABLE] DEFAULT (''),
[MULTI_SELECT] [bit] NOT NULL CONSTRAINT [DF_UD_Field_MULTI_SELECT] DEFAULT ((0)),
[MICRO_HELP] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_UD_Field_MICRO_HELP] DEFAULT (''),
[SEQ] [int] NOT NULL CONSTRAINT [DF_UD_Field_SEQ] DEFAULT ((0)),
[OLD_FIELD_NAME] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_UD_Field_OLD_FIELD_NAME] DEFAULT (''),
[FORMAT_MASK] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_UD_Field_FORMAT_MASK] DEFAULT (''),
[OBJ_HEIGHT] [int] NOT NULL CONSTRAINT [DF_UD_Field_OBJ_HEIGHT] DEFAULT ((0)),
[OBJ_WIDTH] [int] NOT NULL CONSTRAINT [DF_UD_Field_OBJ_WIDTH] DEFAULT ((0)),
[PROMPT_WIDTH] [int] NOT NULL CONSTRAINT [DF_UD_Field_PROMPT_WIDTH] DEFAULT ((0)),
[AUTO_CONVERSION] [tinyint] NOT NULL CONSTRAINT [DF_UD_Field_AUTO_CONVERSION] DEFAULT ((0)),
[DEFAULT_VALUE] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_UD_Field_DEFAULT_VALUE] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[UD_Field] ADD CONSTRAINT [PK_UD_Field] PRIMARY KEY CLUSTERED ([TABLE_NAME], [FIELD_NAME]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[UD_Field] TO [IMIS]
GRANT SELECT ON  [dbo].[UD_Field] TO [IMIS]
GRANT INSERT ON  [dbo].[UD_Field] TO [IMIS]
GRANT DELETE ON  [dbo].[UD_Field] TO [IMIS]
GRANT UPDATE ON  [dbo].[UD_Field] TO [IMIS]
GO